USE [Dosvid]
GO

IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Vacancies_Territories_TerritoryId]') AND parent_object_id = OBJECT_ID(N'[dbo].[Vacancies]'))
ALTER TABLE [dbo].[Vacancies] DROP CONSTRAINT [FK_Vacancies_Territories_TerritoryId]
GO

alter table [Vacancies] drop column TerritoryId
go


